package com.sky.mapper;

import com.sky.dto.GoodsSalesDTO;
import com.sky.vo.SalesTop10ReportVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.time.LocalDate;
import java.time.LocalDateTime;
import java.util.List;
import java.util.Map;

@Mapper
public interface ReportMapper {

    /**
     * 根据日期查询 营业额
     * @param map
     * @return
     */
    Double finOneMoney(Map map);

    /**
     * 根据日期查询 用户
     * @param begintime
     * @param endtime
     * @return
     */
    Integer findSumUser(LocalDateTime begintime, LocalDateTime endtime);

    /**
     * 根据日期查询订单
     * @param begintime
     * @param endtime
     * @param
     * @return
     */
    Integer findEveryOrder(LocalDateTime begintime, LocalDateTime endtime, Integer status);

    /**
     * top  10
     * @param of
     * @param of1
     * @return
     */
    List<GoodsSalesDTO> top10(LocalDateTime of, LocalDateTime of1, Integer status);
}
